VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "clsErrorLog"
Attribute VB_GlobalNameSpace = True
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
'xwelx 04.2010

Option Explicit


'Insert error details on ERROR_LOG table
Public Sub ErrorLog(ErrNo As Long, ErrDesc As String, cModule As String)
Dim sSQL As String
Dim oDB As New clsConnection
    sSQL = "INSERT INTO ERROR_LOG (ErrorNumber, ErrorDescription, cModule, dDate) VALUES " & _
            "(" & ErrNo & ", '" & Replace(ErrDesc, "'", "") & "', '" & cModule & "', '" & Date & "')"
    oDB.cn.Execute (sSQL)
    
    Set oDB = Nothing
End Sub


